SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001713 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001713 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415324,1023805,561956,298790,216595,660147,697606,26176,506678,766551,758099,828857,112602,138302,492301,763444,308298,849877,202400,963374,83441,269398,836302,6622,1030590,610872,919445,852701,48164,798745,49394,664855,98706,764092,332568,965967,400978,93410,765970,28415,290777,29130,370589,455993,208425,139547,847258,520732,446331,693836,589820,972371,958280,771418,545715,874447,626571,432015,799667,706775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001253s ]