SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528144 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528144 [ RunTime:0.004497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195100,187167,449149,131209,895020,971422,619512,185714,132510,313788,574104,992185,954001,341711,1042423,64982,976517,800906,172529,68636,494230,313159,895145,188024,1013720,509511,535883,913304,10808,258122,289036,1007060,773507,525794,635141,674325,499921,479243,947565,309082,220172,717550,268371,63576,177336,965625,312002,396915,929661,429327,715279,69546,730963,747832,114557,543466,776642,879689,704245,861816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001893s ]