SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421198 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421198 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317336,779247,339745,533561,752495,643834,372988,567762,722185,356719,819098,314487,363897,735976,481587,940946,256237,405057,348144,275546,458092,692380,396901,522530,494554,128139,117430,928971,584270,329200,80894,769229,885028,297094,225135,639092,82518,478801,813360,148131,442578,447655,608055,853524,78091,566272,256299,310155,407147,376293,6899,850004,637587,920287,426013,529099,26022,809723,398362,595942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003806s ]