SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016960 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016960 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149022,669501,469315,321670,781137,888082,762941,138200,873354,691691,412158,666052,479352,183966,664661,659379,130221,329563,751612,232139,476881,41837,246655,880965,76374,440923,661052,433657,824888,261891,859738,516459,788509,176978,329206,70625,651739,324832,340185,579009,512302,512374,273061,670227,198323,826986,618321,438127,864542,201933,413025,974012,659181,160977,189507,739173,916524,614559,39135,663837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000882s ]