SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031405 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031405 [ RunTime:0.006834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595082,583683,633239,231277,971610,1020206,592646,394432,486054,728729,884410,456309,1009140,275121,832390,989041,761546,116550,868313,938524,296345,789663,566068,36851,202484,22316,66518,93057,228959,218336,735660,389587,946107,110704,583211,386019,85660,608532,558767,331780,39508,773132,556180,972250,40234,376051,396516,502906,635155,541579,567720,860634,885025,1023147,124611,1036520,147810,687739,117189,127735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]