SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491427 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491427 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271596,743525,876446,1045332,901124,801248,602525,137678,1041222,341292,1021229,1021691,85041,904308,287465,1026985,275433,109419,3015,485018,708921,882017,187959,2361,474142,623901,575229,978629,852574,378938,527592,191470,343783,710788,1000960,438572,681337,941000,79937,967220,51863,981190,250953,158400,186655,780258,32170,342151,319161,835539,974248,97493,190374,576976,838715,57464,239503,580751,22035,743715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]