SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015720 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015720 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655187,871867,534177,447969,95454,981502,37122,565218,877430,69475,441460,276341,581140,984550,862335,879736,522179,717205,615671,496295,583769,538571,466919,878317,13261,488840,466790,356829,262756,84734,622887,379834,977698,865189,992536,618027,78089,282873,853620,881263,533866,880912,41023,276089,372734,498496,421257,430476,828313,395752,129595,387364,197094,448693,651550,724395,416530,683926,947457,583622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015720 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015720 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002674s ]