SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001658s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043159 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043159 [ RunTime:0.002559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576697,119619,862863,873876,1017898,124520,26954,206164,429877,135893,175119,308903,829014,461451,23145,70104,734627,485955,280554,776172,596483,424564,837352,739695,167139,710946,603794,11064,977671,509285,943516,424804,61541,345002,866244,850413,294867,617804,571146,475167,256583,793982,1014201,953897,817103,1045028,541943,249630,937337,330152,210277,730902,28983,771776,589797,488960,570645,1001561,633075,1000003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]