SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38800 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38800 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868293,257925,30873,49173,990865,652484,669568,650829,388652,685936,601275,690989,637117,947069,591615,57149,676273,330819,650541,36982,131867,375430,816762,1019030,47489,515336,612985,814217,886721,275242,762657,414177,717914,208731,166495,791302,553950,842330,1002255,768413,75323,969334,750047,548880,120284,547606,284191,268578,118745,1022033,593185,823959,99691,630637,963284,95270,724131,892880,404868,917692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]