SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103916 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103916 [ RunTime:0.002384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637160,945439,345649,197762,932586,326534,1035871,634269,278709,761416,617380,417325,212032,526034,536827,590290,926518,954155,751818,788200,40509,265087,332008,333605,232327,885235,619728,252902,851629,18453,852910,746039,523028,694464,602173,221479,738905,1031822,355950,147565,386826,955510,286310,348465,292979,431111,819820,299586,373418,210406,701004,675737,744229,19027,318148,304638,726450,47075,51129,305584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]