SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294560 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294560 [ RunTime:0.002272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765869,180558,30468,288282,110070,75654,605803,869726,857159,355118,517066,733934,955876,661101,892106,356035,229474,417724,722375,965041,53316,598553,502500,161354,366049,308517,917899,608492,290802,478586,678439,169063,142629,60649,479603,748216,572575,175457,103358,464796,12413,32158,373485,813942,89915,33207,662281,236372,112859,675299,735751,1040323,732904,674080,504209,90097,390190,235706,479710,428574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]