SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503015 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503015 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967959,921279,305149,889382,1030450,801398,439643,875854,815384,38501,154782,766381,947391,561400,792136,787848,185346,462500,192833,927996,626731,1026102,922892,446693,613806,862570,573190,563830,790414,131155,292749,305982,673142,199030,1020022,974347,816714,972209,573576,141572,711197,474088,112286,713350,324717,915580,628862,571511,762008,488935,793039,530511,484658,397411,400338,165924,491034,212465,443272,643395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]