SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691728 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691728 [ RunTime:0.006498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630330,70186,752197,537671,200821,917686,213634,244493,179476,321481,544450,92780,725684,977897,150852,48454,857500,178814,648505,775980,276305,1009084,902680,205447,785456,841208,596457,481619,153787,861723,604897,982968,499179,475161,915700,876305,556463,561439,367554,574828,89617,803026,656371,901033,996242,574621,355849,493494,740577,990397,447115,31935,311609,185598,287962,949168,580186,765429,619022,441762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]