SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483523 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483523 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041977,734239,860692,577203,671580,1006652,654053,111915,924825,323648,350403,765641,519704,358210,294623,968471,266389,630571,847258,84806,244617,760697,553886,863025,713348,980074,829951,497667,516306,2469,728512,1028869,1035472,291474,337525,395871,571948,722247,912884,216574,422810,349309,850239,595762,339455,501922,401550,814257,792093,29929,867975,413630,546668,982966,494236,289803,414681,1045297,976594,200062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]