SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509211 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509211 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476654,954872,363067,1035151,450285,722918,424127,8377,218507,784881,660748,692952,533222,102690,263856,629084,1025749,74890,329954,110511,782049,570149,735134,23331,546630,447925,720673,95842,765031,450841,358631,82512,432786,602263,181330,962363,448289,93039,706687,307584,778156,1012203,196624,989700,274548,425160,894513,640144,865510,952104,889061,237586,841965,779253,112963,953512,14470,478171,796925,94097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]