SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001663s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540618 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540618 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033142,679887,1037398,476252,565099,111353,211016,319234,1021157,652173,516062,902775,294657,198919,768968,1002939,330757,128768,107427,1047327,346130,455320,227379,340713,1019296,54187,470444,455432,13502,909177,862488,846897,724088,193077,959826,306391,745910,146921,107348,996302,728003,738486,1013339,642679,273338,1044956,356813,241283,285363,119752,690081,509481,379510,369913,525297,257750,456277,1010773,1021796,281769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]