SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281002 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281002 [ RunTime:0.002996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841988,943708,780027,86833,138242,199573,161679,945196,848351,101406,55178,284062,1025714,453150,889152,864864,952332,1013129,1801,393234,395512,391367,788136,213679,837008,785630,368124,541548,819625,211393,304484,274648,433115,145679,201725,546850,156911,296480,378974,543100,578084,173959,739084,978268,857836,78599,546509,313059,415851,506215,827002,113275,228853,950075,200725,584802,665256,874954,700637,251172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]