SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002766s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283528 LIMIT 1 [ RunTime:0.001119s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283528 [ RunTime:0.003771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209899,1026702,151265,276245,319862,133788,478155,580485,340970,767871,110608,94527,71572,198974,418029,538795,769973,409085,412705,328730,1007483,227997,786620,468105,304092,190676,320815,627769,335096,74743,325711,349135,528934,336450,922072,820240,868232,804042,675450,915958,964098,908003,750990,393985,37934,807183,574565,796684,743026,642372,691952,720707,653742,816782,415236,219614,65923,627380,102989,348193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003325s ]