SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506197 LIMIT 1 [ RunTime:0.001640s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506197 [ RunTime:0.004692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896202,98391,815586,177361,44795,469945,966985,68830,410668,1035576,43743,1046500,445352,535306,352775,442048,148958,272080,123966,209980,526195,307556,802776,324058,980904,797540,476492,1004525,677148,60066,922193,902200,677237,503602,520216,382123,511902,704343,755914,406016,160718,356391,57272,1030406,371680,193867,926928,299231,20159,503475,238111,722783,142903,496413,541223,832897,386445,893054,11429,169143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]