SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 714080 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 714080 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751006,77189,188577,129707,886155,497125,880505,305144,504901,1032461,938777,630970,1003472,100113,900703,422822,10821,952137,578159,273745,875993,57903,404232,458088,106395,96031,966903,491145,214841,1034349,766981,65920,851329,316033,516519,455665,1042729,197036,625482,91218,185208,1007499,813381,358818,651645,546324,1040663,857319,953653,901024,912660,824231,446170,753327,983580,727738,623216,789006,238176,76265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 714080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 714080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]