SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525354 LIMIT 1 [ RunTime:0.004500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525354 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563745,1011097,778533,295723,676135,242832,817370,170846,837566,216486,300922,737270,529386,1044756,463271,190340,481463,891854,307052,114120,29651,76673,546403,493015,149787,492391,486100,245399,274191,895376,386891,438429,99840,810164,568694,813585,57712,299806,870283,878389,828154,417162,734912,513972,727710,724195,73064,879298,959381,474056,645011,733500,781441,346340,209641,215567,436424,872111,21896,1014180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001980s ]