SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540950 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540950 [ RunTime:0.002863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371718,352882,271799,716075,437107,576636,959613,786087,931001,350670,900188,647797,235118,521624,329852,904418,299037,146936,76406,473292,254826,377165,946517,783513,383963,258769,483040,564976,338129,381113,235326,976418,104137,190762,722642,1023718,981036,77927,303961,962403,950468,16972,832415,869244,264280,127597,572438,67593,382774,103194,941153,26081,667590,480330,903524,271291,334490,1044760,978549,32892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]