SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499760 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499760 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371104,867909,144121,768547,252026,889606,828673,40964,490022,384283,363404,120431,327670,811858,351304,728580,127180,154164,876979,962214,148929,350875,913406,606166,513944,986414,664038,379970,488429,932235,901277,466622,46851,534408,602361,671111,821994,147767,146895,950401,912439,749440,557156,379921,309477,64589,527398,259707,415917,399231,1028323,621236,81267,351899,1011304,901120,596324,146906,792544,363634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]