SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549217 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549217 [ RunTime:0.004412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281430,946798,969316,540705,870561,673158,350133,363093,284613,410713,322205,581728,828919,409988,198839,392430,167580,640492,526639,415792,770075,19149,12278,446377,52993,139103,916391,345924,506368,664241,722704,397782,590399,909743,285018,899228,4970,638372,548365,174637,504951,601852,153183,203222,656827,37885,898131,985408,819876,953751,429251,154130,184944,594310,768559,442821,634909,883046,681975,231332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]