SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477410 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477410 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573673,833058,479714,768215,908891,664800,414395,670669,253122,603886,994403,1030124,836852,80281,74556,923403,957592,322464,270740,667535,20617,267596,880434,312913,293104,285228,155539,181614,702341,361899,611578,724919,343696,379159,619291,819794,892682,820416,625580,737978,447158,449042,975382,824263,473769,706290,895557,271204,978412,1003348,306885,289490,573818,416586,640409,54855,206872,583940,515769,725993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]