SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532770 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532770 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578891,349487,265340,640727,356770,284398,1046181,370999,751439,494199,706370,1009170,254949,686624,1005744,736003,485504,43874,536581,543973,918938,578927,934221,4891,802069,211930,189826,582575,981371,842481,336302,735669,1041389,681281,979539,153188,707205,938380,731543,704194,621318,173938,924424,758332,700497,920205,433966,190351,182837,379635,131024,290407,688084,390388,821513,959936,115733,239806,252327,158426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000805s ]