SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387523 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387523 [ RunTime:0.002490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102331,834583,684874,166399,46755,221748,574388,735331,424128,585656,619850,400677,503796,127981,1010495,416318,200381,457522,941684,997503,1008996,269207,1042167,52751,161385,696819,716136,473158,581579,81807,426060,839144,975139,616039,866932,914390,550446,351735,437465,317382,374627,33920,684375,65387,633219,51348,436508,520302,585397,515961,369252,283976,86968,375216,900908,846915,888658,848838,852564,815248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]