SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002911 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002911 [ RunTime:0.002943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029702,492751,482925,180883,868102,932454,106048,836045,669640,296037,651241,606741,391809,837471,1026748,137094,271902,312198,544890,584075,254393,84199,311727,168531,643621,711604,721133,433716,894666,467301,778100,167534,940287,347326,819525,115961,538877,132684,816885,836634,811427,88080,693325,495422,672341,227869,737135,561754,207375,453063,503124,574900,1038528,912346,110554,546218,649515,993088,594982,495078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]