SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544997 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544997 [ RunTime:0.002246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401846,922811,214491,438721,908118,956392,218814,929808,263193,872403,522310,331690,392231,1048014,1028237,1016643,157945,13068,915062,554189,792210,629685,902637,29498,715992,572033,366459,610650,629634,835948,115890,146314,220093,204691,925407,465973,157840,607680,570827,563508,894181,743865,453487,677441,600826,1009150,114556,573399,967888,59761,611406,168984,794362,949462,91978,829230,801753,543124,258580,35789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]