SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002709s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841917 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841917 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499190,294167,498984,737695,575194,734723,724073,176042,186789,463543,384258,601788,145321,1021800,238402,817294,82383,660371,534395,735632,1017794,25411,71842,323835,100397,798631,110146,643167,579624,444376,983430,982787,444081,189183,909839,542910,381497,258667,148231,671238,846364,183472,807528,82754,832826,175110,144557,579036,395780,938973,208993,318975,202555,428866,111208,643670,197787,476744,850729,934496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001785s ]