SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540623 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540623 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752414,386431,454351,274176,875888,55510,107877,341137,199902,997675,701711,813849,362762,614855,453040,802208,734635,330509,380526,546059,331410,52792,414447,129415,119188,709703,1032425,11379,162899,656532,632187,666736,823269,158109,985480,697707,817206,105571,708007,615851,485123,95850,665947,805298,518350,339615,954816,285872,1039294,134893,712815,375714,583058,741483,497154,716297,496074,771365,19882,638633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]