SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53805 LIMIT 1 [ RunTime:0.000585s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53805 [ RunTime:0.005506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133664,267853,845072,548231,241934,932950,564911,219387,365783,575390,572358,321740,921150,78081,89271,817570,259489,270530,413943,775197,669205,246951,548862,33365,808701,267384,153553,900392,204136,201719,808783,673091,307309,94052,535250,167632,495424,64415,790141,716974,978130,775315,210574,814220,465670,256919,202066,877679,1041849,63580,1021870,590216,706091,278297,184317,299394,770227,425871,698522,8365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003321s ]