SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280180 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280180 [ RunTime:0.002139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755362,690750,925340,948009,547702,247435,912171,513691,908280,754539,594113,555127,433718,315940,124997,356306,929451,731783,721483,381432,250220,863395,88715,403023,592339,743820,91100,753019,312378,407789,188662,334232,519708,414068,728704,131469,411137,280164,489769,858205,310130,803323,696531,495186,398563,55968,1006680,1048137,361293,854216,107274,832949,788542,790704,379346,958617,861185,451509,163199,340135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]