SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320648 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320648 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780560,755508,374772,950057,362793,90575,124515,426626,31483,532587,547669,766541,927854,670854,103916,673924,1019169,214328,720088,906830,729150,849618,381451,382379,953465,230213,780296,219056,136598,761273,928670,295397,227550,647782,640355,433768,413028,375885,842296,1002347,352255,893278,829165,494275,249122,1034309,392144,384742,369771,254535,975537,722666,28653,803454,77164,726882,947848,983990,606463,94437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]