SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426716 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426716 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911782,485724,279320,1009150,855366,516014,579801,727539,486427,1030965,26681,523708,281281,505909,804848,832523,586202,706726,805959,181714,965770,967480,295407,150657,383037,640569,174735,911931,954817,189412,471146,856786,940890,155806,441038,711731,388516,431972,589093,899188,543799,952842,354570,790476,658098,1043647,73154,776411,654636,501265,588296,766275,459446,256269,956417,881681,629727,922939,470595,663054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]