SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417391 LIMIT 1 [ RunTime:0.000607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417391 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376573,1040067,377673,559786,8319,623852,66491,1005471,481053,586826,426952,13682,411042,24102,111227,956960,709692,121434,837090,459798,378412,82109,875898,866322,245501,15228,710533,785158,459703,432388,66554,187603,1029403,235044,283860,903749,931856,193701,479872,634050,382930,969570,529359,161995,919772,858911,167571,802763,37231,815506,106739,934386,871508,401331,985720,366596,836356,87116,773032,373203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]