SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245040 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245040 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156660,831829,42012,884238,633175,101115,357196,443645,458816,779042,1001049,1043261,241001,137254,93006,351832,420737,895441,110375,948270,429273,744328,435271,89354,458241,825379,606268,823817,217017,914236,412337,598131,734110,765685,1039346,423383,1039519,753198,987285,487456,619493,128259,515079,11096,879496,493809,982673,681756,609958,57864,260557,367836,247074,150534,697537,813177,430818,240759,810736,887007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]