SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027477 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027477 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768571,402632,653358,7047,508000,142453,337348,183114,135965,141847,408012,137426,299310,917544,980536,84985,34819,839014,987240,975561,750352,425802,580560,512538,1037137,464610,5473,356894,391900,172313,910700,319555,1041535,728140,660180,227639,447100,866888,451812,1029921,448437,180365,140797,477137,577708,930545,18106,747003,797934,190605,214517,865204,281691,249386,928478,82270,896317,50777,603753,738266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027477 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027477 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]