SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42093 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42093 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453759,890150,342460,538310,259438,618192,563026,250711,70180,628739,92508,282997,31694,366375,510336,936011,624276,845520,236849,325978,906919,700252,267264,656283,288630,733152,665420,988916,764940,356627,1010668,529043,648903,894136,468835,414840,261748,49715,488709,322224,125004,746100,260497,520685,84498,220121,455346,581673,961636,663710,145079,144840,388618,932734,132107,65242,291097,991957,429948,812521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001493s ]