SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002505s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504805 LIMIT 1 [ RunTime:0.000654s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504805 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175130,750675,444620,1006656,1035012,949290,811178,525826,87856,40503,807724,933078,998074,297620,469882,975541,1032166,11846,379545,860681,272101,347180,995394,749847,897400,475123,236836,515704,887580,474760,15933,674852,781112,825125,461199,1009214,769560,77351,111085,475127,800637,846248,255522,482661,15522,942553,544796,872678,878422,1037841,25783,190958,1048821,987543,761979,666845,122517,837930,978019,246913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]