SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023380 LIMIT 1 [ RunTime:0.002527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023380 [ RunTime:0.002782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683118,919542,869162,379196,518471,459983,502123,638277,379974,606764,196402,613955,179601,320749,301643,133717,745242,707192,664446,128682,809683,99547,857546,532493,615240,383027,687038,518278,698737,148667,318005,247079,838481,271324,651747,306572,838261,9135,173119,666835,472282,93062,416382,852803,936764,494348,300361,35511,203102,492301,556412,408650,596491,458071,765411,435884,197241,359799,126644,592731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]