SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804311 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804311 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611672,629505,931462,958484,283030,597753,65605,563370,588271,852612,961227,441620,559169,850845,366167,790108,367378,236142,630993,1028702,46693,277647,733661,41554,948297,561530,546952,934882,731812,935067,91623,697356,147576,559557,355820,388769,469683,945558,547967,48423,563324,237591,495016,865644,844463,694572,243810,1030753,718335,12361,641411,225899,472487,794282,813587,564468,337370,335713,287872,968585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002695s ]