SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10094 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10094 [ RunTime:0.006877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734480,281916,617453,901087,686801,38479,457350,609789,213961,110392,203460,671487,505744,520311,967125,671712,415032,255323,82458,284110,321666,926791,591615,136199,713733,413657,954857,837792,983700,727233,658542,44790,800515,182739,721033,1008742,1015748,320611,916004,54080,1023518,203718,38762,32831,1029565,568750,905760,822844,670270,984020,63604,137882,454413,554540,988630,776274,361127,870721,976752,451126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]