SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014942 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014942 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39534,35938,991673,306578,343305,590987,930536,415158,26260,968228,697890,741304,840527,398721,502031,318671,644844,235163,18376,357290,326750,888286,892484,574822,329503,411110,804430,428965,659249,330539,713967,18968,1030552,761036,175696,744078,623813,483910,193143,73753,744696,903355,225011,325199,272789,656667,826958,380018,629189,734414,624544,148500,4013,365361,389773,723698,550506,776994,244712,456942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001269s ]