SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285113 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285113 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506624,996903,681912,567600,932506,30607,618147,192157,233449,222633,395853,871660,1011424,447330,1000725,140153,697943,472524,156725,506184,10990,1029126,988481,619854,692642,117350,479448,404656,200285,890414,413411,245124,338997,277032,31256,800184,647871,987512,556414,233882,548755,855767,888980,756557,848437,502603,61170,318200,418690,679949,161033,623639,896370,833124,898117,624579,986926,688746,639995,172763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001287s ]