SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 903213 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 903213 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007778,833156,299169,324663,370384,577755,845710,595000,72669,482755,368564,111103,794589,1024330,285335,178527,1047710,738279,786377,609182,554300,471359,170027,820349,330112,115607,566626,201524,799180,781327,347456,332147,523744,352678,283213,152584,123849,657922,908657,585655,63592,431516,383115,264052,931142,634252,717500,568963,59227,454029,537120,605635,435741,242422,465214,146726,134481,114619,245831,754472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 903213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 903213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]