SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 941218 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 941218 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940894,331175,856910,352371,17496,253856,940051,242439,264157,484879,543761,398135,557164,976066,409549,900198,804160,500409,765566,882652,890127,508546,66814,678757,268635,147981,673105,288804,444317,904541,272392,232827,35237,965764,207059,677567,394992,903498,1012885,437796,600823,1022155,1035238,846862,881432,1007326,452491,99855,471073,719634,436247,398281,145498,333650,503575,509065,383039,94187,49946,223990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 941218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 941218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]