SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450084 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450084 [ RunTime:0.002694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178404,799856,124898,902001,1048817,609849,57864,967010,212657,292570,529766,323965,209808,295727,401578,262728,618063,433901,73720,928284,88421,1037878,221259,383030,767468,892811,439747,396270,144007,248818,978073,65107,263147,862858,95978,664543,985738,279092,625539,884027,66213,717692,823996,223777,975614,1048238,804636,677222,770130,229973,105610,281524,446880,841296,794135,463210,303374,400176,376061,701531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]