SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205398 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205398 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748832,347488,437675,993669,280030,513659,471741,228427,504532,967444,976666,81829,413676,921691,192736,343174,538399,523022,925958,251857,305784,904568,1033259,768513,499467,180392,819826,451762,1004141,72933,935294,357368,327289,260722,186966,295711,458323,887565,64858,586323,3266,847205,1046409,440028,253364,78499,621701,459503,977222,848824,115313,185181,788268,692218,267547,517492,811648,572179,33991,964091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]