SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437993 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437993 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501926,885727,659534,231301,403568,360321,750483,79054,132772,812313,589727,769461,449170,542715,820479,212335,77115,536713,791109,1034470,839055,1043809,65322,1013429,827624,331595,646299,641462,338294,267387,483123,923868,526586,786798,691495,698624,703342,198704,657548,154702,1008618,133000,44303,425575,74896,757437,298976,316117,1048330,200010,348451,914181,959626,800900,422243,423570,358945,171449,14196,982326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]