SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538053 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538053 [ RunTime:0.005414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918365,741452,504190,556551,558621,668467,1047109,137591,592669,765278,134321,25591,434284,453056,744992,909678,567958,780714,77184,98696,691335,853079,571791,41324,76431,264305,365500,302554,1006917,251516,531130,899659,832514,165103,265818,342529,3575,907562,72416,786083,39580,1012686,195509,640731,431728,485270,108389,694098,85781,79296,77876,694330,407768,976137,470735,124174,1018420,305418,804608,137575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]