SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310523 LIMIT 1 [ RunTime:0.002519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310523 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708520,673301,441779,863884,57746,68700,145128,481959,65106,625071,668230,1005438,87437,1021666,529807,230474,560368,542038,882069,496479,185439,1005564,333503,655582,724322,106600,389030,527914,715556,80228,860442,457644,844056,53033,346593,641533,657334,306239,702702,663558,40575,327025,335392,652077,395731,332711,612780,119740,533933,478519,73564,232411,139933,881859,212272,403621,662393,961917,23635,1019034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001817s ]