SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040320 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040320 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843632,517913,1028909,60132,1011480,130504,956574,926775,970183,974266,682117,339562,785481,661359,956681,995970,103385,210609,223497,951616,439124,278108,248143,958183,236050,946953,349463,541729,780973,770712,944877,27401,421583,625784,628021,28732,699877,9849,911883,360639,158142,585664,728744,272788,95320,60565,515834,457,426835,983786,302030,336386,975794,649856,564760,891246,125396,175622,298072,509180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]