SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043413 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043413 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005151,211441,606387,376234,834911,695201,936426,820177,260732,133751,572715,46519,954226,796220,582803,408835,497378,386344,514435,1038761,915285,932553,756138,849964,398315,540800,979921,1010926,446411,278458,272167,917461,949991,863467,446610,738896,1020753,119819,81965,1022393,233343,556798,594796,319238,1002203,126159,374238,633942,545561,44162,683184,871344,721037,284140,318350,946626,21442,925733,179698,524696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]