SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002778s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509562 LIMIT 1 [ RunTime:0.001048s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509562 [ RunTime:0.004042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844192,346374,850137,855539,253062,308312,871832,424540,411158,318608,177302,9328,956818,525739,340584,244917,660540,143091,749442,73965,431027,988581,705293,856225,130314,941393,400968,962048,442392,741205,548088,813586,891260,381533,973073,24107,1046271,644598,888223,823535,500212,675567,1034787,674821,80598,923695,776632,179779,895329,140800,902393,500034,535263,852513,505421,363631,828306,395930,410152,280854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509562 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509562 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]