SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403407 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403407 [ RunTime:0.001906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549259,523722,872832,994014,766389,706927,18998,161272,558878,18858,547916,84718,777212,617003,221273,567394,235322,554763,891426,230047,686474,487498,702471,123475,480599,592479,153225,694237,168601,549616,30209,968093,943931,443411,883815,49191,587100,60361,247881,516236,833446,455510,768073,744340,106036,440322,660950,203021,35736,943418,696637,245558,531224,921974,736667,213825,696827,913574,187313,634507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]