SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593433 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593433 [ RunTime:0.002798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781237,975242,1015411,249428,465765,355755,958089,533323,449823,296837,344861,345337,986631,999571,952493,40873,254746,795801,44893,744678,121656,823730,186628,209305,624616,486832,398573,473201,701237,73575,714024,506261,165115,575773,50958,113266,125198,1001529,191705,749404,252636,374353,349956,649356,199661,960208,273639,1002886,240030,244652,962336,985498,56709,1042224,150499,1039503,664383,913764,585528,685213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]