SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508352 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508352 [ RunTime:0.002088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928408,1042578,316711,597150,726183,1029073,40271,662752,817863,305282,382698,431823,482099,385694,154318,56477,921959,965455,407736,457326,569565,688762,936978,259586,374797,64691,622839,955586,136602,993569,621825,805714,665613,1048581,911567,768718,767976,355008,958887,744088,531958,702289,893261,497794,767653,792707,713584,487797,959068,221144,211773,713267,332142,838940,487125,609178,890349,408783,350992,390825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]