SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 716403 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 716403 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575499,306673,738072,10759,265858,284010,306279,165687,33829,294376,1011588,287246,788772,156566,292331,590914,865532,578630,202295,326183,251932,319977,857967,560653,280279,129087,618888,610462,342813,422740,648019,21867,535217,58348,45489,992848,667049,493638,109181,556619,890162,934843,946457,494685,389338,574776,605036,709795,1032285,180401,559776,571242,67607,289883,175604,665918,510503,591499,88206,353023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 716403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 716403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]