SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 13989 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 13989 [ RunTime:0.002360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301323,526173,142284,176341,1007102,536645,866009,102226,548665,649436,108407,918479,210123,996890,936304,100052,795223,152013,268786,684509,917237,48534,206008,935562,385008,510665,182271,867021,1141,896529,985320,877112,919413,101016,984791,905662,659978,771325,1042015,986804,730688,944896,912665,192586,982039,532823,26607,996080,441880,1019831,466929,124320,174149,476492,212697,718612,1001008,537544,502507,11274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 13989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 13989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]