SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 642912 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 642912 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023376,604414,503966,610966,306712,118322,286398,324829,602714,336190,25604,47829,49728,138708,454025,912766,292275,273203,787582,92230,817458,650311,208213,190052,1003065,238958,587536,276021,440149,235136,236869,137448,172843,571956,985288,1019940,894694,299920,352369,280091,928618,463851,205186,989224,411603,382295,812305,482917,138323,614450,541763,798804,188810,708873,875327,692307,19791,954862,913169,644572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 642912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 642912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]