SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820541 LIMIT 1 [ RunTime:0.000796s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820541 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344320,466892,246522,258949,552283,358103,494779,442945,185232,412860,532190,726106,1025707,367439,558482,748024,359443,1034362,21857,459781,846322,832752,404607,468355,267973,470018,1030056,235037,38379,870129,1027628,322681,555186,634649,227300,52187,663487,197453,1016661,386320,936395,358108,338621,299606,359109,561956,301733,412778,122735,503876,396465,434570,650727,684457,43987,480511,214670,943229,61476,1036278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]