SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556922 LIMIT 1 [ RunTime:0.000938s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556922 [ RunTime:0.003786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75253,375322,22187,875809,396562,486240,38398,515770,224245,460855,159878,888817,83763,687282,852750,99297,686999,441990,276794,271753,911453,865275,672299,537863,187068,652452,168595,234121,629223,749570,903979,47735,239238,6548,71587,911510,919359,911014,1021861,955157,1039201,522201,983089,62817,745716,144024,392861,14980,828372,213360,302105,885029,364039,617517,372479,445339,109310,577144,282473,802100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002096s ]