SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510254 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510254 [ RunTime:0.004451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125519,271240,312266,634048,51877,9477,438104,288035,417144,757230,1016974,187933,750156,109409,538215,513291,590772,54738,916463,488352,815121,725480,278318,540807,197100,546132,517370,965699,669332,1024235,491944,509554,518503,416986,292767,192303,149486,473136,440757,957758,154563,99135,753009,133058,475263,87256,475065,537414,691460,762294,634161,946089,557974,182898,26253,591893,789514,7769,1006262,725372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001920s ]