SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310185 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310185 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934955,762799,811888,1004366,73541,51880,1019822,812445,397636,881856,746362,604049,9371,400581,1020533,359921,178488,802962,494426,587108,276325,360254,115052,52510,1036585,71593,488308,454905,550855,943064,635631,887018,2946,910038,89999,413596,1030212,995695,603451,695,324351,926696,3,265195,812737,871363,1045053,921349,504512,923515,86299,1021792,740013,921803,462489,926452,982059,542335,113365,418672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]