SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102041 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102041 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668086,734227,402842,751927,977910,668783,410963,363457,884989,945261,15230,762804,603503,476673,764366,613456,650828,51255,194455,142165,400497,185863,140876,751659,895993,800991,691081,1020501,211996,797708,634524,553127,408556,111354,598281,312866,44507,966422,579373,1038898,136448,842236,516445,792276,431322,868187,377781,445720,332631,346839,212876,320188,1039229,11346,687692,697308,280225,927846,657659,937645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000380s ]