SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504326 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504326 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289134,445015,103969,785802,528410,364197,619192,220437,365213,735242,1047197,628729,514196,1014151,362163,699646,6306,780236,69534,291518,776729,907311,39052,782296,385601,570100,637751,768095,815893,541779,202341,296639,215629,847222,1037516,167616,199391,695096,853888,703727,407794,128343,195430,684555,779557,769391,191064,1007287,331714,134893,671424,481324,860828,271158,682018,728354,660047,722162,382478,721115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]